package cn.bdqn.repository;


import cn.bdqn.pojo.Project;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;

import javax.transaction.Transactional;

public interface Asecu_projectRepository1 extends JpaRepository<Project,Integer>, JpaSpecificationExecutor<Project> {

    @Transactional
    @Modifying
    @Query("update from Project set mywrokbench_id = :mywrokbench_id,conductor = :conductor where id=:id")
    public int updatmywrokbench_id(@Param("mywrokbench_id") Integer mywrokbench_id, @Param("id") Integer id,@Param("conductor") String conductor);


}
